package io.renren.modules.sys.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import io.renren.modules.sys.entity.IntelReplenEntity;
import io.renren.modules.sys.entity.IntelReplenVOEntity;
import io.renren.modules.sys.entity.ProductshelvesstcokEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 
 * 
 * @author Mark
 * @email sunlightcs@gmail.com
 * @date 2019-03-20 13:50:54
 */
@Mapper
public interface IntelReplenDao extends BaseMapper<IntelReplenEntity> {
    List<IntelReplenEntity> queryListPage(@Param("name") String name,@Param("shelvesid") int shelvesid,@Param("categoryid") String categoryid,
                                          @Param("currPage") int currPage, @Param("pageSize") int pageSize);

    List<IntelReplenEntity> queryList(@Param("name") String name,@Param("shelvesid") int shelvesid,@Param("categoryid") String categoryid);

    int queryListcount(@Param("name") String name,@Param("shelvesid") int shelvesid,@Param("categoryid") String categoryid);

    List<ProductshelvesstcokEntity> queryProductStockByPid(@Param("productid") int productid);

    List<IntelReplenEntity> getStatistics(@Param("name") String name,@Param("shelvesid") int shelvesid,@Param("categoryid") String categoryid);
}
